SQL Reference

doogiePIM database supports a subset of SQL commands. It includes the most widely used SQL statements for data manipulation and definitions.

EG: SELECT, INSERT, UPDATE, DELETE, CREATE TABLE, ALTER TABLE, DROP TABLE, CREATE INDEX, DROP INDEX.

SQL commands should be separated by semi-colon ( ; )

Supported SQL commands

SELECT Statement

INSERT Statement

UPDATE Statement

DELETE Statement

CREATE TABLE Statement

ALTER TABLE Statement

DROP TABLE Statement

CREATE INDEX Statement

DROP INDEX Statement

START TRANSACTION Statement

COMMIT Statement

ROLLBACK Statement